----------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\research\china\decentralization\restat_data\results\table1&A1.log
  log type:  text
 opened on:  22 Jul 2016, 09:37:43

. 
. 
. ****regenerate light variables for conveniency
. gen light1990_cp=f101992_cp90

. gen light1990_pref=f101992_pf

. gen light1990_pfcp=f101992_pfcp

. 
. gen light1995_cp=f121995_cp90

. gen light1995_pref=f121995_pf

. gen light1995_pfcp=f121995_pfcp

. 
. gen light2000_cp=f152000_cp90

. gen light2000_pref=f152000_pf

. gen light2000_pfcp=f152000_pfcp

. 
. gen light2005_cp=f152005_cp90

. gen light2005_pref=f152005_pf

. gen light2005_pfcp=f152005_pfcp

. 
. gen light2010_cp=f162009_cp90

. gen light2010_pref=f162009_pf

. gen light2010_pfcp=f162009_pfcp

. 
. gen sampgdp = gdpsect2_1990_pfcp~=. & gdpsect2_2000_pfcp~=. & gdpsect2_2010_pfcp
> ~=.

. sum gdpsect2_1990_cp gdpsect2_2000_cp gdpsect2_2010_cp if D0==1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
gdpsec~90_cp |        241    17.77936    36.41598        .43    406.761
gdpsec~00_cp |        203    71.92403    110.8333       2.62     911.56
gdpsec~10_cp |        257    346.0061    515.6253       7.04   3822.187

. sum gdpsect2_1990_pfcp gdpsect2_2000_pfcp gdpsect2_2010_pfcp if D0==1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
gdps~90_pfcp |        241    12.33309    12.55962        .25      91.36
gdps~00_pfcp |        201    87.29907      114.42   2.799999   694.7233
gdps~10_pfcp |        255     445.587    590.5395   9.690002   4334.139

. tab gdpsect2_1990_pref_impute if D0==1 & sampgdp==1

gdpsect2_19 |
90_pref_imp |
    uteflag |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |         96       50.79       50.79
          1 |         93       49.21      100.00
------------+-----------------------------------
      Total |        189      100.00

. 
. 
. **************Table 1*****************************************
. 
. * 1990 Levels
. gen D = 1

. table D if D0==1, contents(mean censuspop1990_cp mean censuspop1990_pfcp) format
> (%15.0f)

--------------------------------------------
        D | mean(censusp~p)  mean(censusp~p)
----------+---------------------------------
        1 |          955683          2953557
--------------------------------------------

. table D if D0==1, contents(N censuspop1990_cp N censuspop1990_pfcp) format(%15.0
> f)

--------------------------------------------
        D | N(censuspop1~p)  N(censuspop1~p)
----------+---------------------------------
        1 |             257              257
--------------------------------------------

. 
. table D if D0==1 & sampgdp==1, contents(mean gdpsect2_1990_cp_df mean gdpsect2_1
> 990_pfcp_df) format(%15.2f)

--------------------------------------------
        D | mean(gdpsect~f)  mean(gdpsect~f)
----------+---------------------------------
        1 |            9.28             6.56
--------------------------------------------

. table D if D0==1 & sampgdp==1, contents(N gdpsect2_1990_cp_df N gdpsect2_1990_pf
> cp_df)

------------------------------------
        D | N(gdpsec~f)  N(gdpsec~f)
----------+-------------------------
        1 |         189          189
------------------------------------

. 
. **** Distribution of GDP growth (which matches figure 1b)
. gen grgdp1990_2010_cp = (gdpsect2_2010_cp_df-gdpsect2_1990_cp_df)/gdpsect2_1990_
> cp_df
(42 missing values generated)

. gen grgdp1990_2010_pfcp = (gdpsect2_2010_pfcp_df-gdpsect2_1990_cp_df)/gdpsect2_1
> 990_pfcp_df
(47 missing values generated)

. sum grgdp1990_2010_cp if D0==1 & sampgdp==1, detail

                      grgdp1990_2010_cp
-------------------------------------------------------------
      Percentiles      Smallest
 1%     .9898263       .5549056
 5%     3.140018       .9898263
10%     4.182119       2.426442       Obs                 189
25%     5.945014       2.799201       Sum of Wgt.         189

50%      9.44161                      Mean           12.83226
                        Largest       Std. Dev.       12.2709
75%     14.48189       53.69418
90%      21.6053         60.062       Variance       150.5749
95%     37.85048       73.40614       Skewness        3.30706
99%     73.40614       93.03038       Kurtosis       16.95145

. sum grgdp1990_2010_pfcp if D0==1 & sampgdp==1, detail

                     grgdp1990_2010_pfcp
-------------------------------------------------------------
      Percentiles      Smallest
 1%    -2.809838      -17.44873
 5%     2.062844      -2.809838
10%     4.625375      -2.372038       Obs                 189
25%     8.904886      -1.239082       Sum of Wgt.         189

50%     14.54137                      Mean           18.24878
                        Largest       Std. Dev.       25.5967
75%     20.82759       61.32602
90%     31.14368       72.82156       Variance       655.1909
95%      43.2801       116.3376       Skewness       8.586154
99%     116.3376        313.743       Kurtosis       96.39858

. 
. foreach var in "censuspop" "light" {
  2.   foreach unit in "cp" "pfcp" {
  3.      
.   egen sum_`var'1990_`unit'=sum(`var'1990_`unit') if D0==1
  4.   egen sum_`var'2000_`unit'=sum(`var'2000_`unit') if D0==1
  5.   egen sum_`var'2010_`unit'=sum(`var'2010_`unit') if D0==1
  6. 
.   gen gr_`var'9000_`unit'=(sum_`var'2000_`unit'-sum_`var'1990_`unit')/sum_`var'1
> 990_`unit'
  7.   gen gr_`var'0010_`unit'=(sum_`var'2010_`unit'-sum_`var'2000_`unit')/sum_`va
> r'2000_`unit'
  8.   gen gr_`var'9010_`unit'=(sum_`var'2010_`unit'-sum_`var'1990_`unit')/sum_`va
> r'1990_`unit'
  9.   
.   }
 10. }
(29 missing values generated)
(29 missing values generated)
(29 missing values generated)
(29 missing values generated)
(29 missing values generated)
(29 missing values generated)
(29 missing values generated)
(29 missing values generated)
(29 missing values generated)
(29 missing values generated)
(29 missing values generated)
(29 missing values generated)
(29 missing values generated)
(29 missing values generated)
(29 missing values generated)
(29 missing values generated)
(29 missing values generated)
(29 missing values generated)
(29 missing values generated)
(29 missing values generated)
(29 missing values generated)
(29 missing values generated)
(29 missing values generated)
(29 missing values generated)

. 
. *** Deflated GDP Sector 2
. foreach var in "gdpsect2" {
  2.   foreach unit in "cp_df" "pfcp_df" {
  3.      
.   egen sum_`var'1990_`unit'=sum(`var'_1990_`unit') if D0==1 & sampgdp==1
  4.   egen sum_`var'2000_`unit'=sum(`var'_2000_`unit') if D0==1 & sampgdp==1
  5.   egen sum_`var'2010_`unit'=sum(`var'_2010_`unit') if D0==1 & sampgdp==1
  6. 
.   gen gr_`var'9000_`unit'=(sum_`var'2000_`unit'-sum_`var'1990_`unit')/sum_`var'1
> 990_`unit'
  7.   gen gr_`var'0010_`unit'=(sum_`var'2010_`unit'-sum_`var'2000_`unit')/sum_`va
> r'2000_`unit'
  8.   gen gr_`var'9010_`unit'=(sum_`var'2010_`unit'-sum_`var'1990_`unit')/sum_`va
> r'1990_`unit'
  9.   
.   }
 10. }
(97 missing values generated)
(97 missing values generated)
(97 missing values generated)
(97 missing values generated)
(97 missing values generated)
(97 missing values generated)
(97 missing values generated)
(97 missing values generated)
(97 missing values generated)
(97 missing values generated)
(97 missing values generated)
(97 missing values generated)

. 
. *** Report Growth
. tabstat gr_censuspop9000_cp gr_censuspop0010_cp gr_censuspop9010_cp if D0==1

   stats |  gr_cen..  gr_cen..  gr_cen..
---------+------------------------------
    mean |  .2545947   .230184  .5433823
----------------------------------------

. tabstat gr_censuspop9000_pfcp gr_censuspop0010_pfcp gr_censuspop9010_pfcp if D0=
> =1

   stats |  gr_cen..  gr_cen..  gr_cen..
---------+------------------------------
    mean |  .0385893  .0096394  .0486007
----------------------------------------

. tabstat gr_light9000_cp  gr_light0010_cp gr_light9010_cp if D0==1

   stats |  gr_lig..  gr_lig..  gr_lig..
---------+------------------------------
    mean |   .518604  .3312359   1.02162
----------------------------------------

. tabstat gr_light9000_pfcp  gr_light0010_pfcp gr_light9010_pfcp if D0==1

   stats |  gr_lig..  gr_lig..  gr_lig..
---------+------------------------------
    mean |  .9385264  .3648642  1.645825
----------------------------------------

. tabstat gr_gdpsect29000_cp  gr_gdpsect20010_cp gr_gdpsect29010_cp if D0==1 & sam
> pgdp==1

   stats |  gr_gdp..  gr_gdp..  gr_gdp..
---------+------------------------------
    mean |  1.581149  2.770161  8.731348
----------------------------------------

. tabstat gr_gdpsect29000_pfcp  gr_gdpsect20010_pfcp gr_gdpsect29010_pfcp if D0==1
>  & sampgdp==1

   stats |  gr_gdp..  gr_gdp..  gr_gdp..
---------+------------------------------
    mean |  3.430415   3.00288  16.73442
----------------------------------------

. 
. 
. *********** Table A1 ***************
. 
. #delimit ;
delimiter now ;
. sum 
> all_road_2010_rays all_road_1999_rays lall_road_2010_km_pfcp po_s_all_road_2010_
> ringxda rail_2010_rays lrail_2010_km_pfcp
> road_1962_rays lroad_1962_km_pfcp po_s_road_1962_ringxda rail_1962_rays lrail_19
> 62_km_pfcp ruralMigp00
> D_censuspop9010_cp D_censuspop9010_pref D_gdpsect2_9010_cp D_emp9010_cp D_emp_ma
> n9010_cp D_manuempT9508_cp 
> larea_cc90 larea_pf05 province_capitalPlus lcensuspop1982_pref frac_highedu1982_
> pref share_emp_man1982_pref lkm2coast sh_highedu1982_cppref sh_emp_man1982_cppre
> f sh_pop1982_cppref
> if D0==1, separator(0);

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
all_road_2.. |        257    3.809339    2.028756          0         12
all_road_1~s |        257    2.894942    1.741232          0          8
la~0_km_pfcp |        257    6.167876    .8139011   .4032361   8.195533
po_s_all_r.. |        257    .2879377    .4536855          0          1
rail_2010_~s |        257    1.848249    1.261017          0          6
lrail_2010~p |        257    4.550677    1.421866          0   6.709159
road_1962_~s |        257    2.035019    1.381639          0          6
lroad_1962~p |        257    5.333059    1.008213          0   7.334577
po_s_road_.. |        257    .0505837    .2195736          0          1
rail_1962_~s |        257    1.155642    1.246518          0          5
lrail_1962~p |        257    2.826132    2.172592          0   6.360787
 ruralMigp00 |        257    72752.02      134588          0    1178439
D_ce~9010_cp |        257    .4092692    .3074216  -.2455283   1.749425
~op9010_pref |        257    .1384035    .2022655  -.2476666   1.826532
D_g~_9010_cp |        241    3.192429    .6053111   1.149607   5.298092
D_emp9010_cp |        257    .2330027    .3287257  -.3810212   1.664039
D_emp_man9~p |        257   -.1856214    .7496606   -2.45648   1.870002
D_m~T9508_cp |        257    .3336844    .5858364  -.8933439    3.20723
  larea_cc90 |        257    7.109766    .9486629   4.631307   9.911949
  larea_pf05 |        257    9.316174     .741204   6.943104   12.02702
province_c~s |        257    .0972763    .2969118          0          1
lcens~2_pref |        257    14.86429    .6564473   12.65108   17.11027
frac_~2_pref |        257    .1153998    .0439858   .0246621    .289761
share_emp_.. |        257    .1183518    .0895909   .0136415   .4611437
   lkm2coast |        257    5.236596    1.875163   -5.37838   7.384181
sh_highedu.. |        257    .3730434    .2107936   .0518802          1
sh_emp_man.. |        257    .5002335    .2179298   .0890805          1
sh_pop1982~f |        257    .2694277    .1918718   .0214261          1

. #delimit cr
delimiter now cr
. 
. log close
      name:  <unnamed>
       log:  C:\research\china\decentralization\restat_data\results\table1&A1.log
  log type:  text
 closed on:  22 Jul 2016, 09:37:43
----------------------------------------------------------------------------------
